alter table jms_dm.dm_cusc_demand_taking_network_summary_dt
    set tblproperties ('external.table.purge' = 'true');
drop table jms_dm.dm_cusc_demand_taking_network_summary_dt;
CREATE EXTERNAL TABLE jms_dm.dm_cusc_demand_taking_network_summary_dt
(
    sign_early_scantime       string COMMENT '第一次签收时间',
    taking_early_scansitecode string COMMENT '第一次揽收网点code',
    taking_early_scansitename string COMMENT '第一次揽收网点名称',
    taking_agent_code         string COMMENT '揽收网点所属代理区code',
    taking_agent_name         string COMMENT '揽收网点所属代理区名称',
    taking_fran_code          string COMMENT '揽收网点所属加盟商code',
    taking_fran_name          string COMMENT '揽收网点所属加盟商名称',
    taking_provider_id        string COMMENT '揽收网点所在省份id',
    taking_provider_desc      string COMMENT '揽收网点所在省份名称',
    taking_city_id            string COMMENT '揽收网点所在城市id',
    taking_city_desc          string COMMENT '揽收网点所在城市名称',
    need_call_num             string COMMENT '应电联量',
    have_call_num             string COMMENT '已电联量',
    call_rate                 string COMMENT '电联率',
    gt6_seconds               string COMMENT '通话时长大于6秒',
    gt6_seconds_rate          string COMMENT '6秒接通率',
    performance_bill_num      string COMMENT '履约票数',
    performance_bill_rate     string COMMENT '履约率'
)
   COMMENT '按需配送揽收维度汇总(粒度网点)'
    PARTITIONED BY ( dt STRING COMMENT '日期第一次签收时间')
    STORED AS PARQUET
    LOCATION '/dw/hive/jms_dm.db/external/dm_cusc_demand_taking_network_summary_dt'
    TBLPROPERTIES (
        'discover.partitions' = 'false',
        'parquet.column.index.access' = 'true'
        );